2017-06-01 - 17735 - Enhancement - BI Report Enhancement - INV600 #CrystalReportsSupport
ENHANCEMENT
17735 - BI report enhancement - INV600
Requirement Summary
Need to add 3 parameters for Specific Tab/Status, Stock Type and Purchase Requisition in report.
Admin Info
| Purpose |
Need to add 3 parameters for Specific Tab/Status, Stock Type and Purchase Requisition in report. |
| Requested By |
Saravanan Lakshmanan |
| Spec Created By |
Dhananjay G |
| Spec Created Date |
06/01/2017 |
| Spec QA by |
Uday Kumar P |
| Objects |
INV600 |
| Document Status |
Complete |
Estimates
| SNo |
Activity |
Estimation in Hours |
| 1 |
Research |
08 |
| 2 |
Documentation |
02 |
| 3 |
Development/ Config |
22 |
| 4 |
Unit test in DEV |
02 |
| 5 |
Unit test in QUA |
00 |
| 6 |
Other activity |
00 |
| TOTAL |
35 |
References
Prior Tickets
47657Documents
INV600 - Material Requirements Planning Report.xlsxSpec Changes
| SNo |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
Add Open PR to the Purchase Requisition prompt list |
Saravanan |
06/07/2017 |
IM |
| 2. |
The report shows only 'A' Stock Type..Investigation require for this issue. |
Saravanan |
06/30/2017 |
IM |
| 2 |
Remove ALL in PR Prompt List ans set default as 'Open PR'. |
Saravanan |
07/12/2017 |
IM |
Functional Requirement
Purpose/WHY:
The report will be too big to download for the whole plant due to this reason add more parameters to restrict the data.In Scope:
Global Region.Out of Scope:
Other Regions.Solution Summary
1. Added 3 parameters for Specific Tab/Status, Stock Type and Purchase Requisition in report.
2. Default value set for 3 parameters is 'ALL'.
3. Allowed single value to Specific Tab/Status, allowed multi value to Stock type and PR having list of values as attached screenshot below:
4. Given the logic for Open and Closed PR's as shown below:
Open PR - EBAN.EBAKZ <> 'X'
Closed PR - EBAN.EBAKZ = 'X'
5. Validated the report with the user and the report outcome meets the expectations of the user by NEC.
6. Removed 'ALL' in PR Prompt List ans set default as 'Open PR'
Test Plan
| SNo. |
Test Scenario |
Expected Results |
| 1. |
Report Format. |
As per NEC standards. |
| 2. |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3. |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Solution Details
1. Added 3 parameters for Specific Tab/Status, Stock Type and Purchase Requisition in report.
2. Default value set for 3 parameters is 'ALL'.
3. Need to implement the logic for Open PR and closed PR in report.
4. Need to remove 'ALL' in PR Prompt List ans set default as 'Open PR'
Issues
None